class AddInviteUserTable < ActiveRecord::Migration
  
  def self.up
    create_table :invitations do |t|
      t.column :user_id,    :integer    # so we can reply by email
      t.column :invited_id, :integer    # -1 if email not found in the db
      t.column :key,        :string     # key to this record
      t.column :name,       :string     # name given by the sender
      t.column :email,      :string     # invited email
      t.column :created_on, :datetime   # when email was sent
      t.column :project_id, :string     # project name
      t.column :msg,        :text       # attached msg
    end
  end
  
  def self.down
    drop_table :invitations
  end
  
end
